﻿Imports System.ComponentModel.Component

Public Class CustomDatagridViewComboboxColumn
    Inherits DataGridViewComboBoxColumn
    Dim _CboProductDataTable As DataTable

    Public ReadOnly Property CboProductDataTable() As DataTable
        Get
            Dim mysql As New ClsSQLhelper
            Dim strsql As String
            Dim DT_Item As New DataTable
            strsql = "SELECT item.alternatenumber,item.itemname from item where siteid = " & My.Settings.CurrentSite & "  order by itemname "
            DT_Item = mysql.GetMYSQLDataTable(strsql, "item")
            'Me.CboItem.DataSource = DT_Item
            'Me.CboItem.DisplayMember = "itemname"
            'Me.CboItem.ValueMember = "alternatenumber"
            Return DT_Item

            Return _CboProductDataTable
        End Get
    End Property



End Class
